package com.yunji.ylexpiration.service;

import com.yunji.ylexpiration.entity.FurnCommodity;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface FurnCommodityService {
    //查询摆件花艺的,limit为6
    List<FurnCommodity> selectByClassificationtype_idandLimit6(Integer [] classId);

    //查询摆件花艺的所有id
    List<FurnCommodity> selectById();

    //查询墙式壁挂的,limit为16
    List<FurnCommodity> selectByClassificationtype_parent_idandLimit16(Integer [] classId2);

    //购物车---根据id查询商品信息
    FurnCommodity selectByid(Integer comid);

    //查询墙饰壁挂的所有id
    List<FurnCommodity> selectById2();

    //查询分类的所有商品
    List<FurnCommodity> selectByClassificationtype_parent_id(Integer snum,Integer price, String typename,String typename2,Integer pagenum,Integer pagecount);

    //查询分类的商品总数量
    List<FurnCommodity> CountByClassificationtype_parent_id(String typename,String typename2);

    //查询墙式壁挂、蜡艺香薰、创意家居
    List<FurnCommodity> selectByClassId(String typename,Integer [] classId3);

    //搜索查询
    List<FurnCommodity> searchByProductName(Integer snum,Integer price,String productname,String productname2,String productname3,Integer pagenum,Integer pagecount);

    //模糊查询的商品数量
    List<FurnCommodity> SearchByCount(String productname,String productname2,String productname3);

    //根据id查询详细信息
    FurnCommodity selectDetailById(Integer id);

    //详细信息中的为你推荐7条数据
    List<FurnCommodity> recommendByfirve(Integer ClassId,Integer ParentId);

    //详细页码的猜你喜欢,显示相关类型的数据15条,且销量排名前15
    List<FurnCommodity> RelatedByLimit15(Integer ClassId,Integer ParentId,Integer pagenum,Integer pagecount);
}
